﻿CREATE TABLE [dbo].[CountryProgramme] (
    [Id]             UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [CountryId]      UNIQUEIDENTIFIER NOT NULL,
    [Address]        NTEXT            NULL,
    [PrimaryPhone]   NVARCHAR (50)    NOT NULL,
    [SecondaryPhone] NVARCHAR (50)    NULL,
    [Fax]            NVARCHAR (50)    NULL,
    [Email]          NVARCHAR (100)   NULL,
    [WebAddress]     NVARCHAR (250)   NULL,
    [ProgrammeName]  NVARCHAR (300)   NULL,
    [MBCurrencyId]   UNIQUEIDENTIFIER NULL
);

